Custom Column Micro Chart

Custom Column Micro Chart : This video contains how to use Custom column using microcharts in OPNBI.

1. Login into OPNBI.
2. Make Dashboard to add table widget, to make dashboard click on Plus icon (+) from Dashboard section, as shown I figure below:

3. Insert name & click on create button, as shown in figure below:

4. You’ll reach to an empty dashboard, now click on Table widget icon from the right vertical menu bar, as shown in figure below:

5. Add following details to Table widget:

• Name: sales
• Datasets(ds): Select sales.ds

6. Click on select all field icon from the Dataset columns, as shown in figure below:

7. All available columns will appear in the selected columns box, after selecting all fields, as shown in figure below:

8. Click on Custom columns button, as shown in figure below:

9. After click on custom column, you’ll reach to Custom Columns dialog-box in OPNBI, as shown in figure below:

10. Click on Micro charts tab and click on Add button to add information of Micro Charts.

11. Insert the following information:

• Name: sales
• Display Name: sales
• chart dropdown: select Pie chart
• Column Field dropdown: select quantityOrdered, priceEach columns
• As user selects the columns, it will display in list view, from here user can change the position from up to down using the arrow icons in list view.

12. Click on save button, then click on add button to add the custom column to table widget.
13. The custom column will be added at the end of the columns, drag and drop on the top of the list.
14. Now click on save and exit button from table widget, then go to preview side.
15. As per below figure the custom column will indicate the Micro charts (pie chart).